package xpn.business.fund_return.entity.return_funds_report;

import org.springframework.data.jpa.repository.Query;
import org.springframework.data.rest.core.annotation.RepositoryRestResource;
import xpn.platform.common.repository.XpnRepository;

import java.util.List;
import java.util.Map;


@RepositoryRestResource(path = "returnFundsReport")
public interface ReturnFundsReportDao extends XpnRepository<ReturnFundsReport, Long> {
    ReturnFundsReport findAllByCaseId(Long caseId);

    @Query(value = "select a.branchImgUrl,b.branchSignUrl from ReturnFundsReport a left join ReturnFundsReport b on a.caseId = b.caseId")
    List<Map<String, Object>> queryTest();
}
